public String prepareBindExecute(HrConnection state) throws SQLException { Connection con = state.con; Statement st = null; ResultSet rs = null; String ename = null; try { final PreparedStatement ps = con.prepareStatement("select name from emps where empid = ?"); st = ps; ps.setInt(1, state.id); rs = ps.executeQuery(); rs.next(); ename = rs.getString(1); } finally { close(rs, st); } return ename; }